package com.yunji.base.mapper;

import com.github.yulichang.base.MPJBaseMapper;
import com.yunji.base.bo.MemberQueryBO;
import com.yunji.common.model.domain.MemberDO;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Package com.yunji.user.mapper
 * FileName:	MemberMapper.java
 * Copyright:	Copyright © 2024 云集互联 All Rights Reserved
 * Company:		云集互联
 * @version: 1.0
 * @since: JDK 1.8.0_202
 * Create at:   2024-04-07 02:09:06
 * Description:
 * 顾客数据交互
 * Modification History:
 * Author					Date					Version         Description
 * -------------------------------------------------------------------------------------
 * HuaAo0803@163.com	2024-04-07 02:09:06     1.0             1.0 Version
 */
public interface IMemberMapper extends MPJBaseMapper<MemberDO> {

    @Select({"<script>select distinct ${searchFiled} from member where `status` = 0",
            "<if test='name != null'>and name like concat('%',#{name},'%')</if>",
            "<if test='phone != null'>and phone like concat('%',#{phone},'%')</if></script>"})
    List<String> searchTableField(MemberQueryBO param);
}
